Theres dependency on DBA team to get the database restored to point of time recovery. Turnaround time could be slow , as a result I m looking for alternate...

Sorry i should have mentioned it before . its a varchar column which can have client ids from [0-9] or [a-z].

I tried both doing a cast and convert still getting an error as

Conversion failed when converting datetime from character string. This is what i tried:

SELECT convert(varchar,convert(datetime,'1/6/2012 12:36:35.631951 PM'),100)

yes the column i use do have null values . so in such a situation is there a solution to this? Any help regarding this will be gratly appreciated. TIA

Yes it does. I followed this link for setting the variables. Thanks

http://www.sqlis.com/post/The-Execute-SQL-Task.aspx

Tried substituting the variable with ? instead of User::GroupID.Still not able to get it work. Am i missing anything in initial setting? any suggestions please?? TIA

attached is the document with snapshots. yes i have 2 sql execute tasks 1st one passes a variable to 2nd one which uses that variable to pull data from source...

Thanks for the response . infact i am having trouble storing the value into a variable as i dont see it when i debug the task. so prettty much...

Thanks . Thats what i am trying now but do you have any link which could provide some insite on how it can be done. Thanks a lot

Just to make it simpler how is it possible to make an SSIS pckg as an iterative process for say 10 times for 10 set of clients

Thank you for the response.

Yes we prefer to do it one client ata time reason is for each client there couldbe a million transaction records so when...

Thanks. But calll all the results i get from each sqls statement be appendeded to one file. What i trying is to generate a report which gets counts from different...

Great this is what something i was looking for. so will it give a currval before the insert goes thru? lets say i have 100 recs after insert there will...

thanks yeah i know pivot transformation can be used but just wanted to see how thats set up in SSIS.

Many thanks for your input sqlbuddy. Now i have another strange problem. If i try some table from Oracle database and when i try previewing it i get error as...