After your typecast, run it through a Derived Column transform, and use the following for your expression (bear with me, I don't have my editor open so this is freehand):

(LEN(my_val)...

If you're using a mapped drive (such as M:\my_folder), you will have problems because the account under which you run SQL Agent doesn't care about drives mapped by user logins....

How are you running your SQL Server Agent - is it running under a system account or a domain account? Does that account have access to write to the...

You can set your package setting ProtectionLevel to EncryptSensitiveWithPassword, and set a strong PackagePassword to encrypt the password of the remote server.

hth,

Tim

Unfortunately, there aren't any good tools for this as far as I know. You can add an additional output to your script task and write out debugging information to...

The first couple of things I would check are the file paths and file/folder permissions. It sounds like you may have already verified the former; double-check to make sure...

I attribute my success in this business to taking on additional projects and learning opportunities, both on the job and off. If I had just done my assigned work,...

I'm not sure I fully understand your problem. Are you expecting that all of the records in the destination table will be overwritten? If so, you need to...

What a great loss for the SQL Server community. Does anyone know if Ken had been ill? He was so young.

Thanks Jeff, you are correct - the file I was chasing down was actually not generated using bcp at all but another process. That'll teach me to to assume,...

What Jeff is saying is that if you are always returning the same value, why use the ternary operator at all? Just make your expression "43" to return that...

It looks like you're trying to use a ternary operator, but you've left out the third operand. A ternary statement will contain an evaluation test, a value for true,...

Yes, what you need is the Execute Process Task. You can call the PHP executable (php.exe, if I remember correctly) and pass the location of the script as an...

Take a look at your error message. It indicates that the problem is in the filesystem, perhaps a missing or inaccessible output file.

Hopefully I will be the first DBA to work and live from an RV while exploring our great country (under the age of 40). I will work during the...