Viewing 15 posts - 8,941 through 8,955 (of 13,876 total)
When you are retrieving the file name in the Foreach loop, consider selecting the 'Name only' option to avoid having to dissect the entire path string with your derived column...
November 12, 2014 at 4:17 am
Just a quick check. Can you confirm the data type (in SQL Server) of the new date column please?
November 12, 2014 at 4:12 am
Koen Verbeeck (11/12/2014)
Phil Parkin (11/12/2014)
arunnrj87 (11/12/2014)
Component Properties -- > Under Custom Properties-->In FileNameColumnName--> i have...
November 12, 2014 at 3:16 am
arunnrj87 (11/12/2014)
Component Properties -- > Under Custom Properties-->In FileNameColumnName--> i have five the Column Name...
November 12, 2014 at 3:10 am
Koen Verbeeck (11/12/2014)
November 12, 2014 at 2:05 am
arunnrj87 (11/12/2014)
Actually i have Flatfile as a TXT files .In that i have 100 Columns and i need to import those datas in to SQL Server 2012 by using...
November 12, 2014 at 12:36 am
Try removing the group by completely:
select count(distinct msdb.dbo.backupset.database_name)
from msdb.dbo.backupset
where datediff(day, backup_finish_date, getdate()) > 1 -- or is null
...
November 12, 2014 at 12:30 am
klineandking (11/10/2014)
CREATE TABLE tableValues(
[LASTENCRYPTIONDT] [datetime] NULL,
[ENCRYPTIONID] [int] NULL,
[NAME] [varchar](50) NULL
)
CREATE TABLE TableToupdate(
[LASTENCRYPTIONDT] [datetime] NULL,
[ENCRYPTIONID] [int] NULL,
[NAME] [varchar](50) NULL
)
tablevalues has...
November 11, 2014 at 12:10 am
Does table A have an IDENTITY(1,1) as a PK, by any chance?
If yes, you might be able to do something like this:
1) Set SSIS variable to SELECT Max(ID) from tableB.
2)...
November 10, 2014 at 12:50 pm
cbrammer1219 (11/10/2014)
November 10, 2014 at 11:12 am
MMartin1 (11/6/2014)
November 7, 2014 at 5:18 am
g.britton (11/6/2014)
Phil Parkin (11/6/2014)
I presume this is just an 'out of interest' type question, because when you're deleting exact duplicates from a heap, there is no real row number?
The...
November 6, 2014 at 8:46 am
Nasty.
I think I'd do it like this.
As your OLEDB source, have a query which gives you an ordered resultset
CompanyInfo1, CompanyInfo2, CustomerInfo1, CustomerInfo2 etc
order by Company, Customer
Of course, this is...
November 6, 2014 at 8:38 am
aarionsql (11/6/2014)
From your experience can you get Project Level parameters to be used in SSIS expressions along with other variables?
So you it be...
November 6, 2014 at 8:27 am
Viewing 15 posts - 8,941 through 8,955 (of 13,876 total)