Thanks

I am thinking they will be in TEMPDB

I din't needed the dataconversion transformation either. But I was initially verifying with just the excel source and dataconversion and added a data viewer to see if the data is...

Yes the table was loaded with all the data that is in excel. Try to create a new package and see if it works

I was able to load the data as it is in EXCEL. All the columns are loaded. I do not see any issue. I have sql server 2008 R2 on...

Here is the code

if OBJECT_ID('tempdb..#test') is not null drop table #test

go

create table #test

( column1 varchar(100),

column2 varchar(100),

column3 varchar(100)

)

go

insert into #test

select 'red' as Column1, ...

As Scott suggested , differential backup and a periodic full backup is a lot better solution to your problem. But then I was just giving you out different solutions out...

My solution handles too

You may write the expression something like this in the conditional split

(DT_DBTIMESTAMP)(event_d + " " + event_t) >= DATEADD("HH",-73,GETDATE()) && (DT_DBTIMESTAMP)(event_d + " " + event_t) <= DATEADD("HH",8,(DT_DBDATE)(GETDATE()))

I would run the same process, that loads data into production, on the lower environments. For example if you have a SSIS package which loads data into production. Create a...

You may use a conditional split transformation in the Data flow tab. You can write any number of conditions in this transformation and each condition have a respective output. So...

You can use Replication.

http://www.sqlservercentral.com/stairway/72401/

I solved by running the bids as..."run as administrator". It worked.

steveb: Thanks for your help

I just started learning VB. this example is from book "Microsoft VB step by step".