you might wanna take a look at this post on duplicates

http://www.sqlservercentral.com/Forums/FindPost1126433.aspx

FormatFile would be helpful...

check this for more info

http://msdn.microsoft.com/en-us/library/ms179250.aspx

u can use the conditional split component if im not wrong... try searchin BOL on Conditional Split

I believe you are trying to join 2 tables and insert values to the third table...

Insert into Names_Output1 (Firstname, LastName,UserId)

select a.Firstname, a.LastName,b.UserId

from

tblInput a join Users_Output2 b

on a.UserName=b.users

I have not tested...

Gianluca Sartori (8/4/2011)

---

I guess you need a splitter function, such as the great one desribed by Jeff Moden in his article here[/url].

If you like his code, please consider voting for...

Yes... I believe you cannot use a RAW file[RAW file as in, something created by RAW File Destination and not a text file] in a bulk insert task. The RAW...

Is column23 the last column in the source? there is a fair possibility the row terminator is causing trouble. is it possible for you provide a sample of the source...

@Koen- I believe running execute SQL tasks in parallel should not cause any problem as the values for the variables are evaluated before the tasks are executed[Please correct me if...

Strange.... I tried re creating the scenario... and I dont face the issue... Steps followed

Created variable User::Query set to evaluate as expression

Expression:"select * into test"+ @[User::Stamp] +"...

How is the current date is populated to the variable "User::DateStamp"?

It would be great if you could provide us with the scripts for creating the table and sample data so that we can help you. the below mentioned link will...

Eugene Elutin (7/27/2011)

---

SQL Profiler is a tracing tool, so it does show what has been executed. It's not a debugging tool.

So you will never see what the parameters values are...

Hi Ashish, I am very well...

@Ashish

Can you try this nested stored proc and let me know the result.

create proc testproc (@testval nvarchar(50))

as

begin

select @testval

end

create...

I was facing the same problem.. just that its related to excel and ms access instead of oracle. I was not able to run the package in 64 bit environment...