When accessing data from txt files then the best way to manage this data is use Derived Component straight from source and explicitly give proper type for each column from...

Do you know what is code of this character? Try to use Script Component and trace all chars for this column under debugger and next use character conversion component.

Copy all files from {your project directory}\bin\deployment directory to any directory on the production server.

From this directory on production server run file named as your package but with .SSISDeploymentManifest extension...

OK, but you can copy files between your station and production server? Is it possible to remote run programs on the production server?

Do you have VPN connection to your production server?

7. Copy all files from deployment path to production server.

8. Double click on file with .SSISDeploymentManifest extension an deploy package od production server

9. Choose SQL Server deployment option

10. Select server...

jasmeet_lett (11/19/2007)

--------------------------------------------------------------------------------

Do guide me through.Thank You !

1. In Solution Explorer click on package (top most element) and chose Properties option.

2. Click on Deployment utility

3. Change CretaeDeploymentUtility to true, register in...

Is protection level of your package set to EncryptAllWithPassword?

Is package supplied with PackagePassword?

Is package deployed and you have all files (.dtsx, .SSISDeploymentManifest and others) i deployment directory?

MenTaT 🙂 (11/16/2007)

---

TITLE: Microsoft Visual Studio

------------------------------

Nonfatal errors occurred while saving the package:

Error at FTP Task 1: The object name "BCF_80425_111607.txt" is not valid. The name cannot contain any of the...

With one exception,

I need to have a dynamic file name everytime the FTP fires off.

I have added the dynamic name to the expression property of the FTP object and continue...

Alicia Rose (11/15/2007)

---

I need to post files to another organization and they have to send back a set of excel files.

One option is data exchange through FTP site.

It would be...

1. Drag Data Flow Task on the Control Flow tab.

2. Double click on the Data Flow Task.

3. Drag Ole Db Source on the Data Flow tab.

4. Double click on it.

5....

May be FTP connection was broken? Try to rename files to A, B, C and next to C, B, A. Is the same effect? What is in the message written...

What is the error message?

Drag green line from ole db source and place it on ole db destination. has Ole db source any connection attached to it?

MP