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

Data types. The Excel driver recognizes only a limited set of data types. For example, all numeric columns are interpreted as doubles (DT_R8), and all string columns (other than memo...

I am not sure under what kind of pressure you are working but normally after telling how to do it for one parameter,

you should have done it for others....

nsaxena9 (8/25/2014)

---

Hi,

I have recently taken over the SSIS packages from a colleague who left the company.

I am trying to look for a task that was disabled. Looking at that package...

jkalmar 43328 (8/25/2014)

---

OK, let me try to get you guys what you need...

CREATE TABLE PRE_LOAD(

KitID varchar(20) NULL,

BatteryID varchar(20) NULL,

TestID varchar(20) NULL,

LBSTAT varchar(8) NULL

)

INSERT INTO PRE_LOAD

(KitID, BatteryID,...

Jack Corbett (8/25/2014)

---

There are a few issues with your attempt at an expression in SSRS.

1. 0 can't be converted to a date by .NET (the...

amolacp (8/25/2014)

---

Hello All,

I'm having an issue with adding parameters to the report with the below statement. When I add @Start as a parameter in report and set the default value...

http://www.sqlservercentral.com/articles/Best+Practices/61537/

The reason why asked it is, sometime the data might be there in the right table.

but while querying in the SSMS, if we don't specify the schema name, the...

Do you have any other table named dimClient with different schema?

though MS documentation says that Conversion from DT_STR to DT_BYTES is a legal conversion, Nether data conversion or derived column column compopnents seems be doing this right with out throwing...

nishav2 (8/22/2014)

---

Hi,

I am facing similar kind of problem.I have an SSIS package which has a flat file source and an oledb destination.

I am transferring flat file content to a table.This...

I am jut trying to understand the statement "key columns of a table doesn't performs In Place Updates but does delete and insert"

Isn't every column of table available through the...

how about using the script task.

Lynn Pettis (8/22/2014)

---

One, please make sure to test your code in an empty database prior to posting.

Two, the following works:

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#Table1')...

http://sqlblog.com/blogs/aaron_bertrand/archive/2011/11/03/the-case-against-information-schema-views.aspx