They...

If your input data is in a string, you cannot use date functions on it.

Use substring to extract the parts of the string you are interested in and do...

ronan.healy (9/29/2014)

---

i have a date coming in like this

21/03/2018

I keep getting an error. do I have to convert it I tried the following code to try and convert it but...

antonela (9/26/2014)

---

My stored procedure is not so simple.I have a lot of values for that parameter and I have to do different things for every case.I can not use the...

Not relevant to your question, but I would also be interested to know why you are using a global temp table (##) rather than a local one (#)?

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');