Place a Flat File Destination in your Data Flow task.

Click on your OLE DB Source. See the green arrow? Drag & drop it onto the Flat File...

You could change your OLE DB source to use a SQL Command, then write a query that does your date formatting and zero-padding, or you could leave the source as...

Use the System.IO class in a Script Task.

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.IO

Public Class ScriptMain

Public Sub Main()

Dim f As File

...

By using Package Configurations. Search this site & Google for information on how to use them.

Some information on using variables in a Script Component:

http://msdn.microsoft.com/en-us/library/aa337079%28SQL.90%29.aspx

http://msdn.microsoft.com/en-us/library/ms136033.aspx - scroll down to the section titled "Interacting with the Package in the Script Component."

Public Class ScriptMain

Inherits UserComponent

Dim dblRow As Double

Public Overrides Sub PreExecute()

dblRow = Me.Variables.NameOfYourVariable

MyBase.PreExecute()

...

It's a permissions issue. The account that the SQL Server Agent runs under doesn't have access to that location.

Why not add the TAB to you source SQL using the CHAR function then concatenate it to your new column in the Derived Column component?

Source SQL ex:

SELECT

OrderID,...

Here are a few things to check out:

1) Was this deployed from a 32 bit machine to a 64 bit one?

2) Are you referencing objects in your...

The Expression Builder doesn't use sql.

If the data type of your variable is numeric, this will work:

SUBSTRING((DT_STR, 8, 1252)@[User::pActiveDate], 5, 2) + SUBSTRING((DT_STR, 8, 1252)@[User::pActiveDate], 7, 2) + SUBSTRING((DT_STR,...

I don't think it's necessary. I don't check those files out, I just get the latest version whenever I check a project out of TFS.

None of the files you've...

The .database file contains information that BIDS uses to open the Integration Services project.

Here is some information on the .vspscc (and other source control-related files)

http://alinconstantin.members.winisp.net/webdocs/scc/SccFiles.htm

Without knowing the details of your sql statement, I would say yes, add DISTINCT to attempt to resolve the duplicates.

The first thing that jumps out at me is "The Microsoft Jet database engine cannot open the file 'E:\SampleExcelFiles' ".

Verify that you're including the actual file name and extension.

If that's...

It's a permissions issue. Verify that the SQL Service account has access to that directory.