If there is one feature I'd love to see added is the ability to stronly type worksheet columns, meaning for example that all values within a column would be constrained...

What is the purpose of the LEFT JOIN to addb20.Source_MergeAMD3_WithData.dbo.ConfigChoice?

I ask because that table is not referenced anywhere else in the query.

No. The overlapping has nothing to do with...

Are you asking whether...

Eric M Russell (10/4/2016)

---

Phil Parkin (10/4/2016)

---

New Born DBA (10/4/2016)

---

Experts,

Is is possible to create multiple tables with same tablename and column in multiple databases without selecting each database from the drop...

New Born DBA (10/4/2016)

---

Thanks for your kind response but there are 35 tables and all these tables have to be created in 150+ DBs. I already generated the script from...

komal145 (10/4/2016)

---

Source datatype:

[First Name] [nvarchar](255) NULL,

[Last Name] [nvarchar](255) NULL,

[ItemID] [bigint] NULL,

[E-mail] [nvarchar](255) NULL,

[Address] [nvarchar](255) NULL,

[Address 2] [nvarchar](255) NULL,

[City] [nvarchar](255) NULL,

[State] [nvarchar](255) NULL,

[Zip] [nvarchar](255) NULL,

[Trade...

komal145 (10/4/2016)

---

[Derived Column [24]] Error: An error occurred while attempting to perform data conversion. The source type could not be converted to the destination type.

I keep getting this error again...

New Born DBA (10/4/2016)

---

Experts,

Is is possible to create multiple tables with same tablename and column in multiple databases without selecting each database from the drop down menu and execute the...

Derived Column:

"'"+ (DT_STR, 50,1252) [column]

for a varchar(50)-type column, for example.

komal145 (10/4/2016)

---

I have a package which laods data to excel ,but my manger wants to force column explicitly to string type before we export to excel.

So users just open and...

Eric M Russell (10/4/2016)

---

If for whatever reason the extended event trace doesn't give you what you need about input parameter values, then can also implement procedure call auditing using a...

maikel01 (10/4/2016)

---

Hi Guys,

First post for me here, so i dont know if i am at the right place.

I have a street that i need to dissect a streetname in 3...

Thom A (10/4/2016)

---

This doesn't really sound like an SSIS task, no. Generally SSIS is used for ETL, and what you're doing here is simply checking the data and notifying someone...

Merely repeating your request, rather than answering my question, does not fill me with enthusiasm in terms of providing a useful response, sorry.