Viewing 15 posts - 106 through 120 (of 1,117 total)
Where do you see the error? When executing under BIDS or when executing under SQL Job Agent? If you are seeing the error under SQL Job Agent, you have to...
September 16, 2011 at 5:55 pm
Koen Verbeeck (9/14/2011)
brodak (9/13/2011)
did you get an answer for this?
The only real limition is the size of the machine's memory (RAM) where the package is running on, as...
September 14, 2011 at 2:57 pm
The comment by kramaswamy is incorrect. The package will execute on Server 2. It doesn't matter where it is stored.
September 7, 2011 at 7:23 pm
If you are providing the information from outside, then you can set the package protection level to DontSaveSensitive. This should solve the issue you are having.
September 7, 2011 at 7:22 pm
NLV (9/7/2011)
I am posting one file from source location to destination location thru FTP Upload task in SSIS. While posting I want to create a current date folder in mm-dd-ccyy...
September 7, 2011 at 7:14 pm
This is impossible with the current version of SSIS. You cannot impersonate or use domain credentials other than the credentials under which your package is executing.
So the suggestion with the...
September 2, 2011 at 6:42 am
harry.sh16 (8/31/2011)
Copy operation doesnt work for .mdb files/databases using File System Task, so how would one copy databases in the first place??
Why it doesn't work? It is a regular file,...
August 31, 2011 at 12:44 pm
harry.sh16 (8/29/2011)
Im trying to see if creating .mdb files on the fly is possible at all(.mdb will be my destination and i wish to create a table in it too...
August 29, 2011 at 1:32 pm
akl (8/26/2011)
August 27, 2011 at 6:25 pm
Hi Randy,
Another option would be for you to learn VB.NET programming and implement your script using the .NET framework. VBS is very different animal compared to VB.NET.
August 24, 2011 at 9:49 am
If you can use third-party solutions, check the commercial CozyRoc Data Flow Task Plus. The enhanced data flow task supports dynamic data flows at runtime, so you can process all...
August 24, 2011 at 9:46 am
You are using different OS. This may be the reason why you get such different results.
August 24, 2011 at 9:44 am
Hi Allen,
I would recommend against using ActiveX scripting because it is no longer supported.
Having said that, if you are receiving error on CreateObject function call, then you don't have MSXML...
August 24, 2011 at 9:43 am
Viewing 15 posts - 106 through 120 (of 1,117 total)