Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 39384

SQL Server Integration Services, an ETL tool sold by Microsoft and bundled with SQL Server versions since SQL Server 2005.

2
votes
error Your expression with problems is the one for Batch_as_of_Date (DT_DATE)DATEADD(DAY, -1, GETDATE()) If you don't put double quotes around the first argument SSIS tries to parse it as a column … . Since you don't have a DAY column in your input columns so you get this error message: Attempt to find the input column named "DAY" failed .... So your expression would need to be DATEADD("Day", -1, GETDATE()) This is clearly documented in DATEADD (SSIS Expression) …
answered Feb 16 '17 by Tom V - Team Monica
4
votes
task has to look up a value: Please refer to the guidance on the SSIS team blog: Lookup cache modes When to use no cache: When your reference table is changing (inserts, updates, deletes) ... …
answered Feb 3 '17 by Tom V - Team Monica
5
votes
the QueryActivityCollect.dtsx SSIS package, and uploads data by using the QueryActivityUpload.dtsx SSIS package. For more information see Data Collector Architecture and Processing. I'm not sure …
answered Sep 29 '16 by Tom V - Team Monica
1
vote
send mail task and use the same variable to set the attachments property. If you want to sftp you could use a script task or a third party component as there is only FTP available in SSIS by default, not sFTP …
answered Apr 13 '18 by Tom V - Team Monica
2
votes
Have you tried just adding the extension to the variable like this? sFlatFileConnection = sFlatFileConnection + dtRunDate.ToString("yyyy_MM_dd") + '.txt';
answered Oct 28 '14 by Tom V - Team Monica
2
votes
You don't really have much control over how the SSIS Balanced data distributer control distributes data, but you could influence the order in which the data by the BDD is received. From the docs …
answered Jul 18 '18 by Tom V - Team Monica
1
vote
Integration Services. Please have a look at this MSDN blog post SSIS Catalog Access Control Tips and SQL 2012 SSIS Catalog Permissions …
answered Feb 3 '16 by Tom V - Team Monica
2
votes
see when processing the cube manually but should at least give you a single mail. See this article on SSIS error handling. OnTaskFailed This event is generated only once when a Task "failure", independently of failure occurrence be in the Package context or just in a Task specific. …
answered Aug 9 '16 by Tom V - Team Monica
2
votes
DB 4.0 provider supports excel up to version 2003. The Microsoft ACE OLEDB 12.0 supports new versions of Excel, but also old versions by specifying the version in Extended Properties. In SSIS this is (I believe) specified by choosing the excel version in the connection manager dialog …
answered Feb 19 '18 by Tom V - Team Monica
3
votes
If I understand correctly what you are trying to do I don't think you should put your expression in the Directory property. I think you need to put: Your directory name (C:\NewExcelFile\) in as the …
answered Oct 3 '18 by Tom V - Team Monica
2
votes
If you trace the query the report is generating you'll see that the executions are stored in the [catalog].[executions] of the database behind the Integration Services Catalog. You can just modify yo …
answered May 30 '16 by Tom V - Team Monica
4
votes
If you just transfer the data to another server using SSIS it won't magically appear in the SSAS database, so you would need to change the SSAS solution. If your question is about providing access … to the production database you could use SSIS to transfer data onto another server where the user does have access, but it would need to be access to the database engine hosting the database that …
answered Oct 19 '16 by Tom V - Team Monica
5
votes
You are confusing 2 things in your question. Since you state you have duplicate attribute key errors you are using the the age table as a dimension, but since you also want to find averages you are us …
answered Oct 5 '17 by Tom V - Team Monica
2
votes
The way you handle null or missing data depends on where you have your missing data. If you have missing data in fact tables in your measure columns you should probably leave them as null so they don …
answered Oct 5 '17 by Tom V - Team Monica
3
votes
A common cause of this problem can be the difference between 32 bit and 64 bit installations. If your SSIS package is running in 64 bit the Access driver needs to be installed in 32 bit too. My … documentation for more information dtexec Utility (SSIS Tool) Then it's just a matter of installing the correct drivers (32 or 64 bit) …
answered Feb 5 '18 by Tom V - Team Monica

15 30 50 per page