Viewing 15 posts - 76 through 90 (of 181 total)
I can back up what Thomas has said - I too have only been using SSIS for about 5-6 packages, but have moved to using OLD DB Destination and Source....
August 17, 2006 at 11:39 am
I can see how that would be D£$%£"$%^ irritating!
August 17, 2006 at 9:47 am
Hi George,
While you are waiting for an expert opinion, I thought I'd pop in my 5 cents worth of novice opinion.
You have N tables/spreadsheets to import, and each of them...
August 16, 2006 at 6:59 am
some things to think about (if you haven't already).
What about data in tables?
Re-creating constraints.
You 'could' consider the following process (of the top of my head, so work through it to...
August 16, 2006 at 4:18 am
BTW - does this need to be done in scripts at all? this sounds like something that could be done in SQL.... granted, dynamic sql, but still something done inside...
August 16, 2006 at 4:11 am
glad they were able to help 🙂
August 16, 2006 at 3:04 am
hmm - that sounds a bit bizarre. I must admit, I never use Auto-format - I get a perverse kind of pleasure from formatting the layout myself, especially in making...
August 15, 2006 at 10:01 am
Off the top of my head, I wouldc say you shouldn't use SQl2005 SSMS to manage SQl2000 databases. Time to use the move to SQL2005 to justify reviewing and improving...
August 14, 2006 at 11:30 am
That's interesting Allan. I have 5 SSIS Packages that have quite a bit of annotation in them, and I haven't had any issues yet.
August 14, 2006 at 8:04 am
If haven't tried it because my path location is 'static' - in the sense that I don't need to merge. I was recommended to use the following when I was...
August 14, 2006 at 7:51 am
I do something quite similar. I'm using a .Net script to check for the existance of the file.
The input parameter ExcelFileLocation is a full path. It is handed in via...
August 14, 2006 at 6:47 am
ok, I'll bite again.
You cannot change this directly in SQL server. You need to make the changes via designer, and re-deploy. You could open the dtsx's on the server with...
August 14, 2006 at 3:38 am
I'd be interested to hear a good acnswer to this one. The only thing I can think of is a .Net Script component that takes in the path as a...
August 11, 2006 at 11:55 am
no problems.
Yes, SSIS has the 'File system Task' is the Control Flow pane which covers most of these operations. There are a few that are missing, like MOVE DIRECTORY CONTENTS,...
August 11, 2006 at 8:20 am
If you are in the Control flow, it certainly should be there - in the 'Control Flow Items' grouping - make sure it is expanded. If you are in the...
August 11, 2006 at 3:34 am
Viewing 15 posts - 76 through 90 (of 181 total)