Viewing 15 posts - 5,911 through 5,925 (of 11,676 total)
The first thing you need to know about SSIS is that it is not flexible or dynamic.
If you say you have 10,000 rows and you need 10 Excel sheets, then...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2013 at 6:14 am
Since you'll have to run it periodically, I suppose a job is the preferred method.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2013 at 5:19 am
I found this script when I entered your topic title into Google:
Identifying Long Running SQL Server Agent Jobs
Maybe you need to brush up your Google skills.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2013 at 2:09 am
You can also write C# code in your SSIS packages using the script task or script component. You don't need the full install of Visual Studio to do this, BIDS...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2013 at 2:07 am
I didn't encounter an issue. Someone else did:
http://www.sqlservercentral.com/Forums/Topic1338215-1550-1.aspx#bm1338880
So, it depends 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2013 at 2:03 am
Whoops, guessed wrong. Thanks for the question!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 30, 2013 at 11:57 pm
Nice question, which absolutely no trickery or ambiguity. Thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 30, 2013 at 12:36 am
Shameless plug: there are quite some issues when dealing with Excel and SSIS. This article describes some of them:
What’s the deal with Excel & SSIS?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 29, 2013 at 7:12 am
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 29, 2013 at 5:32 am
DiegoPeña (1/28/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 28, 2013 at 1:43 pm
Did you enable logging in the SSIS package?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 28, 2013 at 7:47 am
Anything weird that pops up in the logging?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 28, 2013 at 7:15 am
Igor Makedon (1/28/2013)
Thank you, Koen. I parenthesized the quoted phrase because I deem it's an implication of "both statements are syntactically correct". Isn't it?
I wouldn't use "correct". If you change...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 28, 2013 at 7:12 am
If you launch SSMS using that proxy account, can you run the sp?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 28, 2013 at 6:39 am
Does the proxy account have permission on the C:\MyFolder\ directory?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 28, 2013 at 6:08 am
Viewing 15 posts - 5,911 through 5,925 (of 11,676 total)