Hi

For birthdate i need to insert in datetime column used derived column

and tried

(DT_DATE)(SUBSTRING("BirthDate",1,2) + "/" +SUBSTRING("BirthDate",3,2) + "/"+ SUBSTRING("BirthDate",5,4))

or

(DT_DATE)(SUBSTRING(BirthDate,1,2) + "/" +SUBSTRING(BirthDate,3,2) + "/"+ SUBSTRING(BirthDate,5,4))

but i am getting...

Hi

Here what you have done.

whether you have taken new bakup or what if you have taken new bakup surely data will...

Hi All

I think i has got the solution (not for sure) UNION ALL transformation under split and join transformations...

It means that i have to create 60+data set correct for each dataset...

steveb. (11/18/2010)

---

Derived column cant have multiple input

/*

Cannot create connector.

The destination component does not...

Hi

create table #mytable1

(Tipo int, Descripcion varchar(20))

Insert into #mytable1

Select 1,'ABCD'

union Select 2,'DBCE'

union Select 3,'DEGF'

select * from...

Hi,

I just copy and past but getting error

public override void CreateNewOutputRows()

{

// Create the StreamReader object to read the input file

System.IO.StreamReader reader = new System.IO.StreamReader(this.Variables.Filename);

// Loop through the file to read...

steveb. (11/17/2010)

---

It seems like you could use 65 seperate flat file connections and then use a derived column to add an ID to differnetiate the files in the destination...

John Mitchell-245523 (11/17/2010)

---

Parthi

It's a cross-post, no matter how you try to justify it. Nobody wants to waste their time replying to this thread, only to find somebody has already...

Hi

With space for AM/PM

SELECT STUFF(CONVERT(CHAR(10), GETDATE(), 101) + ' ' + SUBSTRING(CONVERT(CHAR(19), GETDATE(), 100), 13, 7), 15, 2, SUBSTRING(CONVERT(CHAR(8), GETDATE(), 8), 4, 5))

Without space for AM/PM

SELECT (SELECT convert...

nigelrivett (11/16/2010)

---

How big are the files.

If they are smallish the easiest way to deal with this would be to bulk insert into a staging table with a single column.

Parse the...

I agree Otherwise let me have the attachement of the page...

thanks i cant access i am having permission to access in my work place

It is urgent any one

Can i have Code here not able to visit the site

Thanks

Parth

srinadh.ramineni (11/12/2010)

---

Hi for the below questions i need good and efficient answers.

1) I am having one table and the customer is exported some data from an excel sheet to the...