Viewing 15 posts - 8,986 through 9,000 (of 11,677 total)
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 12, 2011 at 6:13 am
You can insert the rows from the table that contains the SSIS packages (the name escapes me for the moment. I guess dbo.dtspackages) and insert it into the correct table...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 9, 2011 at 6:49 am
Apparently the reference data contains some duplicate values, so you'll need to clean that up a bit.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 9, 2011 at 6:48 am
You can start here:
http://msdn.microsoft.com/en-us/library/ms169917.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 9, 2011 at 6:37 am
JanTimmermans (9/6/2011)
Topic can be closed!!!!I started the wrong procedure !!!!!!:w00t:
Regards,
/Jan
Allright, glad you found the issue 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 6, 2011 at 2:44 pm
Nice question, but I got it wrong by the ambigous column name (not really the point the question was focusing on).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 6, 2011 at 2:40 pm
You can use Visual Basic inside BIDS, you don't need a full version of Visual Studio.
In the dataflow, you can select the Script Component, which launches a shell of Visual...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 5, 2011 at 12:27 pm
Here you go:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 5, 2011 at 11:58 am
If you can execute a perl script with some sort of executable (I don't know anything about Perl), then you can use the Execute Process Task.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 5, 2011 at 11:55 am
Going forth on your vague description, I guess you are working with an Excel file.
Is it possible to post at least the connection string itself here?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 5, 2011 at 11:53 am
How do you write the logfiles?
Do you use a logging provider that logs events?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 5, 2011 at 11:51 am
How do you make the connection to the database?
Are you sure you created the sp in the correct database?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 5, 2011 at 11:49 am
Nice article, but the link to the sister article doesn't work.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 4, 2011 at 11:46 pm
Interesting question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 4, 2011 at 11:43 pm
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 4, 2011 at 11:37 pm
Viewing 15 posts - 8,986 through 9,000 (of 11,677 total)