Viewing 15 posts - 5,911 through 5,925 (of 11,678 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...
January 31, 2013 at 6:14 am
Since you'll have to run it periodically, I suppose a job is the preferred method.
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.
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...
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 🙂
January 31, 2013 at 2:03 am
Nice question, which absolutely no trickery or ambiguity. Thanks!
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:
January 29, 2013 at 7:12 am
DiegoPeña (1/28/2013)
January 28, 2013 at 1:43 pm
Did you enable logging in the SSIS package?
January 28, 2013 at 7:47 am
Anything weird that pops up in the logging?
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...
January 28, 2013 at 7:12 am
If you launch SSMS using that proxy account, can you run the sp?
January 28, 2013 at 6:39 am
Does the proxy account have permission on the C:\MyFolder\ directory?
January 28, 2013 at 6:08 am
Viewing 15 posts - 5,911 through 5,925 (of 11,678 total)