Source is not Unicode, target is not Unicode.

So something in the package must be trying to use...

Karan_W (9/26/2014)

---

All.

Apologies for delay response.

Into SSIS the data type for these column is

text stream [DT_TEXT]

The below string I am retrieving sand inserting to database table.

AA1;20110809;AA55;1009.0000;C15;20110809;AA4;1010.0000;

Is this Unicode string? Please...

Grant Fritchey (9/25/2014)

---

This is exactly why you should be using source control to modify all your database objects, just as developers use it to modify code. Unless you set up...

ronan.healy (9/25/2014)

---

Can an xlsx excel file be read in using a flat file connection.

I tried a few different column delimiters like tab vertical and coma but still doesn't come in...

As Gail intimated, something like this[/url] might be of interest to you.

Please expand on this statement:

Will these tables contain the same columns / datatypes?

Use the following query for your dataflow source:

select b.GROUP_ID, b.NAME, b.STATE

from TableB b

join TableA a on b.GROUP_ID = a.GROUP_ID

where a.STATUS = 'Ready'

Use the INSERT/SELECT syntax from my second example.

Or

INSERT INTO dbo.T1 (column_2)

select col2 from YourTable

Just do the INSERT without using any CREATEs or DROPs:

INSERT INTO dbo.T1 (column_2)

VALUES ('Explicit value');

Are you assigning the file name to a variable? If not, create yourself a variable and ensure that the file name gets...

Are you using a Foreach loop to process the file?

brad.mccollum (9/19/2014)

---

I recently installed SQL Server 2012 on a laptop from scratch.

I notice that when searching for "SQL Server Data Tools" on the system to begin working on an SSIS...

And for those who would rather just click...

I'll be honest, your post is a little tough to decipher 🙂

It seems that you have source data in a table which may or may not have entries for every...