Phil Parkin (1/11/2013)

---

I'd suggest exporting the Excel data to CSV format and importing that instead. You'll save yourself a grey hair or two. Mixed-datatype columns in Excel have cost the...

Koen Verbeeck (1/8/2013)

---

You can reverse the string, look for the position of the second underscore and take the substring starting from that position till the end. Reverse the substring back...

Thanks a lot Dwain.

Its working...

declare @a varchar(100) = 'XX_YYYYYY_DDD_MasterTransaction_120807_00005.TXT'

select LEFT(@A, patindex('%_[0-9]%',

dwain.c (1/8/2013)

---

Here are two ways:

WITH Filenames (fn) AS (

SELECT 'XX_YYYYY_AA_BBB_SampleTransaction_120807_55322.TXT'

UNION ALL SELECT 'XX_YYYYYY_DDD_MasterTransaction_120807_00005.TXT')

SELECT fn=SUBSTRING(fn, 1, CHARINDEX('.', fn))

FROM Filenames;

WITH Filenames (fn) AS (

SELECT 'XX_YYYYY_AA_BBB_SampleTransaction_120807_55322.TXT'

UNION ALL SELECT 'XX_YYYYYY_DDD_MasterTransaction_120807_00005.TXT')

SELECT fn=Item

FROM Filenames

CROSS APPLY PatternSplitCM(fn,...

Koen Verbeeck (1/8/2013)

---

You can reverse the string, look for the position of the second underscore and take the substring starting from that position till the end. Reverse the substring back...

rhythm.varshney (12/20/2012)

---

sqlstud (12/20/2012)

---

Koen Verbeeck (12/20/2012)

---

Enable transactions in your SSIS package. You can either use the built-in transaction mechanism which uses MSDTC, or you can create your own transaction by putting...

Koen Verbeeck (12/20/2012)

---

Enable transactions in your SSIS package. You can either use the built-in transaction mechanism which uses MSDTC, or you can create your own transaction by putting a SQL...

sqlstud (10/16/2012)

---

Hi,

I have one folder with two files

C:\Pkg\28052012_sample.xlsx

C:\Pkg\29052012_sample.xlsx

Using SSIS 2005 i have loaded the data from the above xlsx file using For each loop container.

Query:

Need to move the file to...

sqlstud (10/16/2012)

---

Hi,

I have one folder with two files

C:\Pkg\28052012_sample.xlsx

C:\Pkg\29052012_sample.xlsx

Using SSIS 2005 i have loaded the data from the above xlsx file using For each loop container.

Query:

Need to move the file to...

Excel file is 2007 version and am using ssis 2005. We dont have option to use EXCEL 2007 directly. So using...

It is solved..

i made change in the connection string

Data Source=<path\xlsx filename>;Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties="Excel 12.0;HDR=YES;IMEX=1";

Thanks to all

Regards

Sqlstud

Phil Parkin (10/11/2012)

---

Your Excel column is holding mixed datatypes, so you'll need to bring in the column as string and add IMEX=1 to the Excel connection string (Google it for...

Well it sort of depends on what you want. You currently have a datetime column but obviously "DECLINED" isn't going to work there. If you want to keep your datetime...

Thanks Rhythmk..

I have loaded unmatched data via Erroroutput

Regards

Sqlstud

Thanks Chris and Div

Regards

Sqlstud