No. The reason it is not the same is because when...

Can you connect to this server via SSMS using the IP and same credentials?

You have to use dynamic sql for this one.

e.g.

DECLARE @SQLString nvarchar(500),

@srv VARCHAR(25)

SET @srv = 'MyServerName'

SET @SQLString = N'

SELECT

invoicedate,

invoiceno,

invoicenet

FROM [' + @srv + '].TestPOS.dbo.invoice_header

'

EXECUTE sp_executesql @SQLString

simsql,

You need to do a conversion and round to the nearest whole number. From your post it seems like have a E15 is your largest float. If it...

You need to use the code like this:

SELECT

CAST(MyFloatColumn AS DECIMAL(11,2)) AS [Decimal],

MyFloatColumn AS [Float]

FROM MyTable

You need to set your decimal percision correctly otherwise it will overflow as a general rule of thumb, you can count the digits to determine what you percision should be...

I just did a test where I made an Excel spreadsheet with a column that contain numbers for the first half of the the file then text for the remainder....

I know you can change the data type. Have your tried changing both the "External Column" data type and the output column data type? You can use the...

I believe you may be experience something similar to this bug.

http://support.microsoft.com/kb/194124

This link is for DAO OpenRecordsets. When you drop a Excel source in a dataflow task the connection string is OLE DB. Are you using the Excel source...

You could do something like this:

DECLARE @tbl1 table(

Col1 varchar(10),

dt varchar(15),

ti varchar(10)

)

declare @tbl2 table(

Col1 varchar(10),

dt datetime

)

insert into @tbl1

select 'test', '1/31/2008','11:00 AM'

insert into @tbl2

select 'test2','1/31/2008 11:30 AM'

select...

You can tell SSIS which data type to use for output. It doesnt have to automatically choose. You can right click the Excel Source --> show advanced editor...

There is no...

You will have to create a format file for the bulk insert. Inside the format file you will have to specifiy that after each semi-colon a "|" must exist,...

And to clarifiy when I said it worked. I mean the backup file was deleted successfully.