December 11, 2014 at 3:11 am
Hello everyone,
Sorry for the path, i'm not sure I'm in the right section. But here are my questions.
I'm developing SSIS packages for customer and I'm in front of issues I've never seen before. Hope you can help me.
My configuration :
* Source : SQL Server Database 2008R2 on Network
* Destination : SQL Server Database 2008R2 on local (SSIS installation with SQL Server)
* Environment : WS2008R2, Visual Studio BIDS 2008.
My problems :
I set a DSV for each of my SSRV Databases (1 source, 1 destination) and it works fine using the DSV properties setting. When I set the connections for my packages, I had no issues. So I developed my control and data flows.
The first issue is on my test ! The package is correct but I have to launch it twice... The first one gives me an issue of connection validation every time. The second one works fine !
Second issue is when I test my connection, I have sometimes an error which is : "Unable to connect dut to delay", a second later, the connection succeed...
And the last one, but not the least is on my packages executions. It's lock out my SQL Server account .. And I don't why. Using the SQL Profiler, it says that I have "Login failed for " 3 times and my account is locked for 20/30 minutes... It's not understandable for me because my connections are ok.
Thanks for reply,
Have a nice day,
SR.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply