In Sql Server Configuration Manager I Sql Server Integration Services has status stopped, when I try to start it 开发者_开发技巧aftger few seconds there is an error message: The request failed or the
I have a fact table that has a column with dates loaded from an MS Access source. The thing is, some of the values are NULL and the SSAS won\'t let me refer开发者_运维知识库 my DATE dimension to it.
I got to populate FactTable with 12 lookups to dimension table to get SK\'s, of which 6 are t开发者_如何学JAVAo different Dim Tables and rest 6 are lookup to same DimTable (type II) doing lookup to sa
I have a data set that I import into a SQL table every night.One field is \'Address_3\' and contains the City, State, Zip and Country fields.However, this data isn\'t standardized.How can I best parse
In one SQL Task can I create a table variable DELCARE @TableVar TABLE (...) Then in another SQL Task or DataSource destination and select or insert into the table variable?
I have an ssis (2005) package that uses the web service task to download to a file destination. The file contains a string of xml data. After downloaded the file looks like this. <?xml version=\"1.
I\'d like to know what my best option would be to import data from an excel file on a weekly or monthly basis.At first, I thought I would use SSIS, but after much struggle with seemingly simple tasks,
Does anyone know if it 开发者_运维技巧is possible to do logging in SSIS (SQL Server Integration Services) via log4net? If so, any pointers and pitfalls to be aware of? How\'s the deployment story?
I have a pretty basic SSIS package that is attempting to read a file hosted on a share, and import its contents to a database table.The package runs fine when I run it manually within SSIS.However, wh
I\'m using a files system task inside a for each loop container, just as described here: li开发者_开发知识库nk text
加载中,请稍侯......