Viewing 15 posts - 18,226 through 18,240 (of 26,489 total)
???
From what I have read SSIS 2008 packages can not be run using SSIS 2005.
November 24, 2009 at 9:57 am
Jeff,
Wouldn't a million row setup show what you are talking about? Of course, you could make it ten million.
November 24, 2009 at 9:33 am
I have to agree with Jack, Bob. Thank you taking that initiative to check on Barry. It definitely sets SSC apart from the rest! This is the...
November 24, 2009 at 9:29 am
Is it just me or has Barry gone missing??
November 24, 2009 at 8:33 am
You need to connect to Integration Services on the server.
November 24, 2009 at 7:31 am
Just to be sure, is rowid unique?
November 24, 2009 at 7:22 am
You should be able to script your database for SQL Server 2005 to recreate the database structure in a SQL Server 2005 database and then use export data to transfer...
November 24, 2009 at 7:20 am
SQL Express is free, but if you want to experiment with all the features of SQL Server you can purchase SQL Server 2008 Developers Edition for about $50.00 USD. ...
November 24, 2009 at 7:07 am
Looks like you want the last day of the current month, correct? If so, try this:
select dateadd(mm, datediff(mm, 0, getdate()) + 1, -1)
November 24, 2009 at 7:04 am
It also depends on how many duplicate records vs uniqie records you have in the table. How many unique rows (based on email) are there in the table?
November 24, 2009 at 6:42 am
If I may, you may wish to start by reading about RESTORE DATABASE and RESTORE LOG in BOL (Books Online, the SQL Server Help System that you may access directly...
November 24, 2009 at 6:37 am
I guess it depends how random the random numbers really are in this case. Would probably need to see if there is a way to capture the distribution. ...
November 23, 2009 at 3:49 pm
Nice bit of work there bitbucket. I'd have expected more duplicates in the shorter string with it only being six characters long.
November 23, 2009 at 3:28 pm
What is the source of the data? Instead of a comma delimited file, could you get a pipe delimited file?
November 23, 2009 at 3:21 pm
Viewing 15 posts - 18,226 through 18,240 (of 26,489 total)