It seems wizard is not the option for me as I would like to loop through files and take the data from each sheet in each file. Thanks
I know how to use ssis to import data from the sheet in an excel file.
How do you use ssis to get the data out from different sheets into the...
At present there is no windows server machine in the company.
I would like to install sql server 2005 standard edition on a windows xp pro...
Which version of sql server do I need to be able to install it on my local win xp pro? At present there is no server.
I guess the answer is...
I am using ssis to import .csv files into sql server tables.
How do I get the count of the records imported?
When I run the package it gives the following error warning.
Not sure how and where to fix this.
P.S. The package runs successfully and loads...
There is a table with a lot of fields.
An update query is written such as the following lines:
field1 = table2.field1,
You are right. This is not a show stopper.
I can carry on but it just does not give me the same look and feel during run
No problems with the video card.
Yes. Exactly as arkiboys says.
I am not sure why when the packages are run, the components dissapear. The only thing I see is the result in the output.
So there is no visual on the...
Both the configuration file (dev and prod) are exactly the same.
<?xml version="1.0" ?>
Yes, I copied it from my dev pc to the live server.
yes, same connectionstring for all the packages.
At present the packages are created on my dev pc. There is also a configuration file with the...
I guess I am abit confused now.
Do you mean each package should have a configuration package. And one xml file can be used for all the packages?...
I have created a package configuration to read the connectionstring for the oledb connection manager.
Saved the file as Environment.dtsConfig in the...
I have created a stored procedure which passes variables to the ssis package and then executes the package.
The two variables inside the ssis...
Separate names with a comma.