Does the user 'xxx' exist and have the correct password and permission to log on from the host specified? I see from the error message that no password is being...

Hi,

There are 2 components that perform this functionality. One is the lookup component and the other is the merge join. The lookup component however will only work when referencing an...

You could just use the SSIS system variable [StartTime].

Thats a nice idea. My client uses something similar to trigger the distribution agent job for replication.

I wonder though if this is a 2k5 server, why you would not just...

Not sure if you found an answer to this or not, but if you want a datatype bigger than 255 characters, you use MEMO as your datatype. This maps to...

Sorry I posted my last before I saw your next post...

In which case what you have to do is a multicast. You aggregate one stream and then merge it...

From what I've understood in the original question you wanted the equivalent of T-SQL's:-

SELECT DISTINCT contract nb, version nb, MAX(sequence nb).

You drop an aggregate component on to the dataflow. Connect...

You should be able to use an aggregate component. Let me know if you need help configuring this.

Have you checked the proxy's properties to make sure that it still has rights to execute an SSIS package? Does the login which owns the job have rights to the...

Look, obviously you're frustrated by this, but really we're trying to help. By the sounds of it some changes have been made to your environment. Is it not possible that...

Jeff's right. It's likely a column length issue, but it might not be the destination. It could also be further upstream. If you double click the connector just before the...

These clean up jobs are always tricky.

I think you're doing the right thing already, but I'd go even further with it. The first part is trying to standardise the input...

Hi,

I think what's happened there is that in task 1 you've opened a transaction then closed the connection (I think this effectively rolls back the transaction). Task 2 you've inserted...

Remember aswell that parent package variables are the very last configurations that are read at runtime when calling dtexec. XML and SQL Server configs will be read beforehand regardless of...

Try changing the line:

to

Dim sServer As String = Dts.Variables("myvar").value.ToString

This will probably work for you and remember to set the option to precompile the script as...