CREATE TABLE [dbo].[TONYS_v2](
 [customerfileid] [int] NULL,
 [ID] [int] NULL,
 [Ship to Customer] [nvarchar](10) NULL,
 [sh Long Description] [nvarchar](40) NULL,
 [Item Number] [varchar](25) NULL,
 [Brand Code] [nvarchar](20) NULL,

I am wanting to do this with the least hands on as possible, I have OK?? ssis skills. Also will be doing some transformation on the data when inserting it...

Ok so I have similar problem.

I have a package that reads a file processes it and inserts the data into a table, very simple.
I have all that...

I haven't been able to get this to work, I get an error when using the variable method.

SSIS package "C:\Users\cbrammer\Documents\Visual Studio 2015\Projects\AWG_SalesData\AWG_SalesData\Package.dtsx" starting.

Error: 0xC001C012...

Thank You, I will try this.

If I hadn't looked up different ways to do it, I wouldn't have posted to here in the first place. These are always the type of responses I see and...

You're funny

Can you give an example?

Thank You, that was it..

Yes it is in SIMPLE RECOVERY MODE

I know the backups are being created, however only the diff and full is being backed up, there are no tlogs for some of the DB, I would like to...

That fixed it, I was trying to use a copy of LIVE_OPERATIONS, which is used to refresh data on LIVE_OPERATIONS_BA. So I thought I could use the LIVE_OPERATIONS_BA to use...

So the reason there is duplicate data because there are 2 barns and there is always placement_dates and kill_dates for both. Each are placed on the same date and killed...

The dba before me has a backup process running, network guys are killing the current server and if we manually do a backup and restore it breaks the chain off...

--===== Create the test table with

CREATE TABLE #vb

(

[BoxOnPallet] [int] NULL CONSTRAINT [DF_Boxes_BoxOnPallet] DEFAULT (0),

[BuffID] [varchar](50) NOT NULL,

[DateTime] [datetime] NULL...