Search results for query: *

I can read the query, but could you please put into words exactly what it is that you are trying to do?

If the text file is an excel file, yes, you can import only a specific number of rows. You just query the excel file and then insert into the database table. If the file is a basic TXT file or the like, I would recommend first importing that file into an excel file and then query/insert into...

here is another solution: update dbo.mytable set [ColwithNulls] = '' where [ColWithNulls] is null

set your code to find the file names as a variable (something like "vFilePath") then use the code below: DTSGlobalVariables("SourceFiles").Value = vFilePth When you want to reuse the data inserted into the global variable you will assign the global variable to a variable (like shown below)...

Try this... it will pop up a input box for the executor to enter a username and then a password. '********************************************************************** ' Visual Basic ActiveX Script '************************************************************************ Function Main() dim...

Create a stored procedure that updates the data where needed.

I'm having the same problem, I've been researching this for a while now without any luck. I'll be sure to let you know if i figure out a solution. :)

It sounds like you have way too much clutter in your package. the connection is only used to specify what server/database you are using. If everything resides on the same server(even if the data is in different databases) you only need one connection.

My best guess is that the where clause may not be formed correctly.

All, When I'm importing some data into a table, the values in some places are being changed to scientific notation. I'm unable to use the data that is changed to scientific notation. Does anyone know why this is happening? How can i stop this from happening? Thanks in advance! Simeon