Viewing 15 posts - 1 through 15 (of 30 total)
Which are you intending to create:
A ScriptTask on the Control Panel or,
A ScriptComponent in a Dataflow?
If a ScriptComponent then the Dts reference is not used to access variables. Specify...
May 1, 2013 at 4:13 pm
My WSDL is not that strong but I would go along the lines of using a dataflow in the format:
Data source to get your data which feeds a script component...
February 21, 2013 at 12:47 pm
I use both ScriptTasks and ScriptComponents when I need the power of .NET to achieve a specific function.
ScriptTask - Use the Microsoft.AnalysisServices namespace to dynamically create partitions in SSAS.
ScriptComponent -...
February 20, 2013 at 3:25 pm
Connections to SSAS must be made by integrated security.
Configure all connections through your SSAS to use their own credentials
[font="Courier New"]exec sp_addlinkedsrvlogin @rmtsrvname = 'MySSASLinkedServerName', @useself = 'TRUE'[/font]
January 17, 2012 at 7:24 am
The previous post was using SSIS. It can be solved in the database directly. My MS Access SQL for the join syntax is very rusty but the SQL...
June 25, 2011 at 2:41 am
v-swgar (6/17/2011)
1 Social School1 Null
2 Science Null Null
1 Null Null Hyd
2 Null School2 Null
2 Null Null Mumbai
I need to Insert into the destination and the data...
June 24, 2011 at 3:56 pm
stewartc-708166 (6/9/2011)
However, the SSIS DTEXEC components must be installed on the machine to be used (otherwise the reference assembly will not be available)
Good point 😀
SSIS must be installed even if...
June 9, 2011 at 12:45 pm
If your select statement retuns a single row, for example:
[font="Courier New"]select top 1 a, b ,c from myTable[/font]
where a is int, b is smallint and c is varchar.
To get these...
June 9, 2011 at 12:42 pm
SSIS does not need SQL Server installed on the same machine, unless you require to access SQL server on that box.
To invoke a SSIS package from C#/.NET:
1) Reference assembly...
June 9, 2011 at 5:01 am
I just discovered the answer...
The Microsft Sql Server/100/Tools/Binn/bcp.exe utility uses the following format when writing out a datetime2 value in native raw format (bcp options -CRAW -n):
If this value is...
February 18, 2011 at 6:30 am
I ended up creating a custom PipelineComponent class that I added to SSIS.
The aim was to bulk insert into a SQL Server table, named by a property, but the table's...
January 26, 2011 at 2:38 pm
If you feel that the usability of SSIS BIDS is an issue then please vote for the enhancements within connect.microsoft.com
Feedback on SQL Server (public forum)
Topic: Usability of SSIS BIDS deters...
January 26, 2011 at 2:23 pm
Create the linked server using sp_addlinkedserver
[font="Courier New"]EXEC sp_addlinkedserver
@server='<LinkedServerName>', -- The name that you will call this new server
@srvproduct='',
@provider='MSOLAP',
@datasrc='<ASServer>', -- This is the name of the Analysis Services server.
@catalog='<ASDB>'...
January 17, 2011 at 12:23 pm
I think that I've got an answer to my own question.
I believe that matching constraints excluding foreign keys, primary key and aligned indexes need to be created on the non-partitioned...
December 1, 2010 at 2:08 am
Since the enitre .dtsx package will be version controlled as a single entity, we accept that only one person can check it out and edit it a once.
However in seperate...
November 21, 2010 at 5:01 am
Viewing 15 posts - 1 through 15 (of 30 total)