Viewing 15 posts - 4,411 through 4,425 (of 11,676 total)
The table [msdb].[dbo].[sysjobs] has a version number, which will tell you how many times the job has been modified.
October 22, 2013 at 2:11 am
That should've been dissapointing.
It's also RBAR, not REBAR 😀
October 22, 2013 at 2:08 am
Nice question, a bit easy for BI folks. 🙂
Type 3 SCD is however not supported by the SSIS slowly changing dimension transformation.
I also never encountered this type of SCD in...
October 22, 2013 at 2:05 am
SQLRNNR (10/21/2013)
1. Thanks to Koen. Manning the support lines (SSC) while many of us were incognito. You had the best quip of the week...
October 21, 2013 at 2:24 pm
Sean Lange (10/21/2013)
ericwenger1 (10/21/2013)
Can I get some recommendations on some Database Reverse Engineering Tools?Thanks in advance!
What are you trying to reverse engineer? Are you trying to get a database...
October 21, 2013 at 1:54 pm
system243trd (10/21/2013)
I don't want to run the package from the Server I want to be able to run it from my PC.
Then you need to install Integration Services.
October 21, 2013 at 1:32 pm
It makes sense. Just replace the source table with a flat file source.
Use a lookup component to check if you can find the unique reference number.
Matches are updates, non-matches are...
October 21, 2013 at 12:37 pm
Personally I use the first options as it is much clearer on what you want to achieve.
I think Luis is correct in asserting that both queries are interpreted the same...
October 21, 2013 at 7:49 am
chris.umpleby (10/21/2013)
October 21, 2013 at 7:47 am
Jeff Moden (10/20/2013)
jonysuise (10/20/2013)
To delete a large number of rows switch the recovery model of your database (in your development environment) to...
October 21, 2013 at 7:43 am
Is the structure of the CSV file going to be the same each time? (in other words, the same columns with the same data types?)
If yes, SSIS is able to...
October 21, 2013 at 7:39 am
I assume the mail is sent by SQL Server Agent? Is that Agent job running on the destination server?
October 21, 2013 at 6:36 am
October 21, 2013 at 6:34 am
Storing the table names will work only if you use dynamic SQL.
You create your INSERT SELECT statement in a string variable and you execute it with sp_executesql.
Regarding the business date:...
October 21, 2013 at 6:33 am
ecmpo (10/20/2013)
I want to be able to set the table names outside of the INSERT statement.
You'll need to explain this a bit more. Probably isn't possible.
ecmpo (10/20/2013)
October 21, 2013 at 12:42 am
Viewing 15 posts - 4,411 through 4,425 (of 11,676 total)