Viewing 15 posts - 31 through 45 (of 410 total)
LadyDee,
First things first.... I suspect you are using SSIS and not DTS to do this. As per the other posters, please advise if this is the case as the solution...
September 22, 2008 at 8:26 am
Zenny,
Firstly, apologies for not replying earlier...
There has to be some logical explanation for why your For Each Loop Container is not working. Just a quick question, are you putting the...
September 18, 2008 at 10:58 pm
As long as the driver is installed, it shouldnt be a problem.
One question, SSIS is a complete revamp of DTS, so minimal changes is an understatement.
Why not use the execute...
September 18, 2008 at 9:32 am
Only a pleasure man.
Post with a solution if you can, I havent used it but would like to know the semantics
September 18, 2008 at 9:25 am
My bad...
Didnt read the no column headers fixed file bit...
I know in SQL 2000 you could use a layout file with the BCP utility. Personally never played with it, but...
September 18, 2008 at 9:05 am
Why not try usin the import/export wizard to do all the grunt work for you?
September 18, 2008 at 8:59 am
Lemme get this straight...
You are using a active script task in SSIS?
Why not go for a scripting task if you are looking at reworking this into SSIS?
September 18, 2008 at 8:57 am
SSIS is extremely metadata driven.
A lot of guys hit the pitfall where in DTS they could have a single source, single destination, single transformation, and then through the use of...
September 18, 2008 at 8:27 am
Personal preference is for SQL server, but I know a lot of people rave about XML configurations.
Mine came down to that I had to save some passwords and I didnt...
September 18, 2008 at 8:14 am
Yes, very much so.
Right click on the database, and choose Import/Export (there are various options but this one will illustrate best).
Go through the GUI and remember to save the SSIS...
September 18, 2008 at 8:11 am
From what I can understand out of your active script task it does the following things:
a) Checks to see if a folder exists
b) Creates a new logfile on the existent...
September 17, 2008 at 11:42 pm
Please elaborate on the problems you are experiencing.
If not sensitive info, how about posting the active script
September 15, 2008 at 9:35 am
Sounds like you would need package configurations, which will allow you to manage your connection manager externally from the SSIS package.
Therefore, once you deploy to production, you change the package...
September 5, 2008 at 4:48 am
Small price to pay for dynamics....
😀
OR (sjoe maar hindsight is a beautiful thing...)
How about specifying a connection manager per server and db? Now, at runtime you can specify the connection....
September 5, 2008 at 1:51 am
Viewing 15 posts - 31 through 45 (of 410 total)