Look at the header of the received email and check the MIME type used for encoding.  Usually it should be delivered as base-64 encoded otheres may use octet-stream that has...

Right-Click on your transform data task arrow... Select "Workflow properties"; Select the "Options" tab; Check the "Use Active-X script"; Click the "Properties..." button.

Set your Workflow Script...

Sandra,

Start up SQL Profiler and start a Trace on the server where the Stored Proc is located...  You will be able to see the parameters passed to the stored proc...

Servers usually give a higher priority to background server tasks.  Workstations always give higher priority to foreground applications.  Have you attempted to schedule this package on the server and see...

Have you tried using the Excel formatting options on the column?  It sounds as if it set to General.  Try setting it to Text.

In your transform, force it to be...

It sounds like you are calling a stored procedure from a Execute SQL Task.  Are you using a parameter that is a global variable that cannot be converted to the...

I am assuming that you want to do some processing in a different step to handle the error?

Can you define 2 Global Variables in the package; One Boolean gv_boolFTP, and...

Here is A way, not the best way of course to read in a text file line by line and return it as a rowset:

CREATE PROCEDURE dbo.AgentBatchLoadStatementFile_Read...

Since you only need to get the current Max value one time prior to performing your inserts, I find it difficult to understand why you would use a lookup in...

Yes this can be done several different ways...

Here is how you can do this via Active-X scripting:

  Const DTSSQLStgFlag_UseTrustedConnection = 256            

  Dim objPackage

  Set objPackage = CreateObject("DTS.Package")

  objPackage.LoadFromSQLServer "(Local)","","",DTSSQLStgFlag_UseTrustedConnection,"","","","Child Package Name"

  '*** Set Child...

A quick listing of all commands available, allong with short examples can be found at: http://www.devguru.com under the vbScript heading.

Browse through all the commands of interest and hack away...

You could always revert back to the great and powerful DOS copy command... If I am understanding the question correctly:

copy file1.txt+file2.txt+file3.txt+file4.txt newfile.txt

newfile.txt will contain all the contents of the 4...

Is drive E: a network drive?  Is it attached when the owner of the Sql Server Agent is executing?  Try to write a test batch that copies from C: to...

Your log file is filling up.  Even if you have it set to unrestricted growth and have ample file space on the drive, it can still fill up.  Here is...

Looks like a permission problem on the Package's current execution context.  Enable logging to a file that is local to the server, where the folder allows read/write/create access to everyone.  This is...