Viewing 15 posts - 346 through 360 (of 681 total)
Is the batch file something that you can schedule separately on the remote server? If you're doing a data extraction with that batch file, perhaps you could run it...
March 12, 2009 at 5:39 am
It's not clear in your post what would be the deciding factor for which of the Excel files to use. If you're going to manually run the file every...
March 11, 2009 at 9:51 pm
I agree that Alan's solution would be best, assuming that the other domain has a trust with the domain from which you're running the SSIS package.
Just curious, what operation is...
March 11, 2009 at 9:32 pm
Interesting. I haven't run into that myself - I've used the FTP component quite a bit and generally have no issues with it.
I have found on a couple of...
March 11, 2009 at 9:17 pm
It may be a problem on the FTP site. Can you connect through other tools and successfully send a file consistently? If possible, set up an alternate test...
March 11, 2009 at 2:55 pm
Instead of trying to skip n records and re-run the package, you should consider using the Error Output of your destination component. This will allow you to send the...
March 9, 2009 at 12:34 pm
David,
You do need SQL Server installed to run the SQL Server agent. Although you can install SSIS without SQL Server, it's generally not worth doing so. You'll still...
March 9, 2009 at 7:34 am
You *might* be able to do this, but it's unlikely. For example, if the website allowed the passing of user ID and passwords in the URL string, you could...
March 8, 2009 at 10:44 pm
You should configure your Flat File source to the setting "Redirect Rows" at the row level. This can be found under the Error Output tab. The default setting...
March 8, 2009 at 10:38 pm
Frank The Tank (3/6/2009)
I have a bad feeling that this test server is not as much of an "exact mirror" of prod as I have been led to believe...:sick:
In my...
March 6, 2009 at 9:25 am
Have you looked into the Filesystem Task? It should be able to accomplish each task you mentioned.
March 6, 2009 at 8:45 am
I agree with Grant - no good can come of unionizing. That being said, if I was offered the choice of any 3 benefits to be added, I'd pick...
March 6, 2009 at 7:30 am
Same question also posted over at SQLTeam: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=121110
March 5, 2009 at 9:15 pm
Try removing the space from the batch file folder name. I know it sounds strange, but I ran into this with a package a while back (mine was a...
March 5, 2009 at 8:17 pm
Is this really how people prep for job interviews these days?
If so, could someone point me toward a list of interview questions for neurosurgeons. Might as well aim high.
March 5, 2009 at 8:01 pm
Viewing 15 posts - 346 through 360 (of 681 total)