Questions tagged [sql-data-tools]
22 questions
0
votes
1 answer
Convert datetime to string in expression builder SSIS 2019
I encountered a strange problem, moving from VS2015 to 2019. I've got a variable that is setup like this;
SUBSTRING( (DT_STR,50, 1256)DATEADD("DAY",0,GETDATE()) , 1, 10)
This works perfectly in VS2015 but now when I tried to add the same code in a…
Tomas H
- 57
- 7
0
votes
1 answer
How to get RedGate Sql Prompt to work in SSDT project?
I am working on a SSDT project and I would like to use intellisense and snippet support of RedGate Sql Prompt, but I am unable to get that working. All I get from SqlPrompt is the name of the database and my snippets, nothing about the tables.
What…
haku
- 4,105
- 7
- 38
- 63
0
votes
1 answer
How to Overwrite Database Table Data Using SQL Server Data Tools
I'm currently working on a small project using sql data tools. I'm getting data from excel sheet and write it back to my database table. from the database table I'm generating a report. Time to time I'm updating my excel sheet. but it won't update…
shona92
- 63
- 1
- 12
0
votes
2 answers
Cant change the reference type in a Execute package task SSIS
The reference type in my SSIS reference package task is grayed out and therefor un-editable it is set to external reference where as i need it to be a project reference for deployment purposes.
Is there a way i can fix this?
Keag1
- 141
- 1
- 11
0
votes
1 answer
how to make sense of expression logic in ssis
I am working on a SSIS project that involves unzipping a folder which when extracted contains multiple text files in the same directory using a ForEachLoop Container.
each file will have a different Name.
I have two variables of which variable 2 has…
anchor
- 1,685
- 2
- 11
- 11
0
votes
0 answers
Can't import Eclipse Datatools
I am just trying to import the datatools of eclipse after I installed the necessary plugins for the DTP (DTP, GEF and EMF + XSD).
Eclipse keeps on telling me, that the import cannot be found.
Actually, I am not even able to import ANYTHING from…
schneiti
- 428
- 1
- 8
- 22
0
votes
2 answers
SSRS No Query Designer is Available
I just created a data source and now I'm adding a data set. I'm using a dataset that is embedded in my report and then I go click on Query Designer... and it tells me No cube can be found. I click okay and then it tells me No Query Designer is…
Bee
- 33
- 1
- 6