Technically you can import from word - I've never done it but this link suggests it is possible: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e7987d8c-4f90-4ce1-9ba6-e3460b01248c/is-it-possible-to-extract-data-from-microsoft-word-docx-from-ssis?forum=sqlintegrationservices

Excel is a much more common source for User inputs.

If...

I don't think you can use a variable in a create DB statement.

If you want this to be dynamic, create a package variable with an expression which creates the statement...

No experience of Samba but when I have had to check for completion of file upload I have used the file size to determine if the file is ready rather...

Importing data from Excel is often problematic.

One of the main reasons is that by default the datatype of each column is based on the data in the first 8 rows...

You could do this in SSIS but it's a bit clumsy.

To do this for a single file:

Create a file connector so that each line is read into a single column

In...

To clarify, I would have one ForEach loop for each different file with a single DFT with a single source and destination. No logic required within the DFT.

Jez

Create a For Each Loop for each XL file and set the enumerator to Foreach File Enumerator (usually the default).

Set the Folder and Files - these should really be set...

Or you could use event handlers.

Jez

Aaron,

I had to do something like this.

Rather than checking the file system, I checked the status of the report subscription.

I used ReportServer.dbo.AddEvent to fire the subscription and then...

What are the data types for the columns on the CSV?

Sounds like a column is numeric and wont import a char.

Jez

The update will not return a result set. Change this to None.

Jez

This needs to be an expression not the actual SQL statement.

In the Properties window for the task, click the ellipsis (...), under Property select SqlStatementSource and then click the ellipsis...

If you have an Execute SQL Task you can create an expression for SQLStatementSource

"update table1 set location='\\\\path\\" + @[User::variablevalue'] + "'"

This will resolve for each iteration of the loop....

You are grouping by the account number OAPLUS7FLP.GLMST.GMGLAC which gives one row per account number. You need to group by the description.

You might find it easier to create a...

If the file name is unique then you can put that specific file name in the Files text box and then it only checks for that file.

What it doesn't allow...