Viewing 15 posts - 6,916 through 6,930 (of 9,715 total)
stewartc-708166 (12/3/2010)
There is a difference between the data providers to connect to Excel pre 2007 vs post 2007.
Ah. Good to know. Thanks for clarifying.
December 3, 2010 at 5:34 am
Josh,
Can you give us DDL code for the other tables too? And it would help to know which of those tables in the query is the one that #mytable is...
December 3, 2010 at 5:31 am
If it does need to happen in SSIS, delete via the Execute SQL Task in Control Flow. Don't use the OLE DB SQL Component in the data flow task. As...
December 3, 2010 at 5:27 am
I'm sort of new myself, having taken classes a good while ago, but not having had a chance to implement the information learned from them. So what I'm giving you...
December 3, 2010 at 5:24 am
If you can open up the SSIS packages in BIDS (doubtful if they've lost their project connections), then you can see the path in the Properties window by highlighting the...
December 3, 2010 at 5:21 am
If you're upgrading to 2005, not 2008, I recommend using your Procs as the Source in SSIS. There's better performance and less overhead than doing a table to table pull.
What...
December 3, 2010 at 5:19 am
stewartc-708166 (12/2/2010)
What version of excel source & destination?
Version shouldn't matter to SSIS. Especially if SQL's been properly updated with service packs and what not. I believe MS has been updating...
December 3, 2010 at 5:11 am
If you don't know SSIS, the learning curve can be pretty rough. But there are a few things to remember:
Data Flow Task
Excel Source
Excel Destination
Those are the three objects you'll need....
December 3, 2010 at 5:11 am
Something not mentioned here, but happens in my work environment. Backup files take up space too.
If you're not clearing out your backup files on a regular basis, and they...
December 3, 2010 at 5:06 am
I usually only need the double quotes from SQL Server when my path name has a space in it. You might try it without the double quotes and see what...
December 3, 2010 at 4:52 am
sqldba_icon (12/2/2010)
John Mitchell-245523 (12/2/2010)
It could be that deleting the column freed a certain amount of space on each data page, but...
December 3, 2010 at 4:42 am
During the upgrade process, SQL Server 2k5 automatically creates a schema for every user. It's a "feature" that Microsoft put in for who knows what reason. Schemas are new to...
December 3, 2010 at 4:28 am
Henrico Bekker (12/3/2010)
Hi guys, could we get some comments on the today's QOTD please?Need some more senior input.
Yeah, but honestly, Microsoft could be more clear in their KB article too.
December 3, 2010 at 4:24 am
T-SQL is required to create the snapshot, but how many people create snapshots using jobs or SSIS packages? Most people open up SSMS to do it, ergo, the common perception...
December 3, 2010 at 4:22 am
Craig Farrell (12/2/2010)
How often do you re-write old code, except for a few specific core procs on any system?
Often enough that I save all my procs so I can re-use...
December 2, 2010 at 11:53 am
Viewing 15 posts - 6,916 through 6,930 (of 9,715 total)