Hi Todd,

I looked at the example you have provided but was not able to move forward

In my scenario ,I have 2 Tables

Tbl_AreaCode

305,954,234,123

I need to pass the area codes...

Hi Brandie,

I'm facing the same issue but not able to figure out wt the issue is .

Im attaching a screenshot of the same error i got . could you give...

Hi

If you are trying to loop through files and load the data and the file name to the target table?

In that case Inside "derived column" toolbox you have Variables...

Hi Kraig,

We cannot create a identity column on the table, it is a varchar field.

Is there any other way we can accomplish this ?

concatente 001-00- to 000001 (first number in the list)

in my case 1 is different from 000001

It works like a champ

Thank you very much Chris !!

Thanks Luis for your reply,

Sample Data with decimal(18,0) datatype to be converted to datetime2

19970811

19970811

19970811

19970811

19970811

19970812

19970812

19970813

19970812

19970812

19970812

As the Datatype is in Decimal i convert into Varchar(27) as i need to convert to datetime2

Query...

Hi ,

I need to convert the varchar(30) to datetime2 in SQL server , which works well in a select statement

-select

--cast(convert(datetime2,cast(clx.aprvdt as varchar(10)),101)as datetime2) ApprovalDate

--from CLMEXPM clx where clx.aprvdt<>0

but...